CREATE EXTERNAL TABLE ai_dw.train_sample(
                                            `id` string COMMENT 'md5ID',
                                            `receiver_province_id` int COMMENT '订单省份id',
                                            `receiver_province_name` string COMMENT '订单省份名称',
                                            `receiver_city_id` string COMMENT '订单城市id',
                                            `receiver_city_name` string COMMENT '订单城市名称',
                                            `receiver_area_id` int COMMENT '订单区域Id',
                                            `receiver_area_name` string COMMENT '订单区域名称',
                                            `receiver_detailed_address` string COMMENT '订单详细地址',
                                            `receiver_full_address` string COMMENT '订单全地址',
                                            `network_id` int COMMENT '网点id',
                                            `network_code` string COMMENT '网点code',
                                            `network_name` string COMMENT '网点名称',
                                            `first_code` string COMMENT '一段码',
                                            `second_code` string COMMENT '二段码',
                                            `third_code` string COMMENT '三段码',
                                            `change_flag` int COMMENT '变更标识 ：1变化，0未变化',
                                            `change_time` string COMMENT '网点围栏更新时间',
                                            `last_sign_time` timestamp COMMENT '派件签收时间',
                                            `sign_province_id` int COMMENT '签收网点省份id',
                                            `sign_province_name` string COMMENT '签收网点省份名称',
                                            `sign_city_id` int COMMENT '签收网点城市id',
                                            `sign_city_name` string COMMENT '签收网点城市名称',
                                            `sign_area_id` int COMMENT '签收网点区域Id',
                                            `sign_area_name` string COMMENT '签收网点区域名称',
                                            `sign_full_address` string COMMENT '签收网点全地址',
                                            `geo_coordinate` string COMMENT '高德爬取的geo经纬度',
                                            `poi_coordinate` string COMMENT '高德爬取的POI经纬度',
                                            `waybill_no` string COMMENT '运单ID',
                                            `sign_finance_name` string COMMENT '代理区名称',
                                            `sign_finance_code` string COMMENT '代理区code',
                                            `city_id` string COMMENT '签收网点城市id',
                                            `pick_network_code` string COMMENT '寄件网点code',
                                            `staff_code` string COMMENT '派件员编码',
                                            `staff_name` string COMMENT '派件员名称',
                                            `waybill_province_id` int COMMENT '运单省份id',
                                            `waybill_province_name` string COMMENT '运单省份名称',
                                            `waybill_city_id` string COMMENT '运单城市名称',
                                            `waybill_city_name` string COMMENT '运单城市名称',
                                            `waybill_area_id` int COMMENT '运单区域Id',
                                            `waybill_area_name` string COMMENT '运单区域名称',
                                            `waybill_detailed_address` string COMMENT '运单详细地址',
                                            `waybill_full_address` string COMMENT '运单全地址',
                                            `is_addr_equal` int comment '订单运单地址是否相等：1相等2不等')
    COMMENT 'GEO地址信息模型训练表'
    PARTITIONED BY (
        `dt` string COMMENT '日期分区')
    ROW FORMAT SERDE
        'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'
    STORED AS INPUTFORMAT
        'org.apache.hadoop.hive.ql.io.parquet.MapredParquetInputFormat'
        OUTPUTFORMAT
            'org.apache.hadoop.hive.ql.io.parquet.MapredParquetOutputFormat'
    LOCATION
        '/dw/hive/ai_dw.db/external/train_sample'